The specified fields are not uniquely indexed in table <name>. (Error 3374)

The specified fields in the referenced table of a CONSTRAINT clause are not uniquely indexed.